<!-- ************************************************************************************************************ -->
<!-- fileName          : admin_rightguide.jsp 																	  -->
<!-- summary           : admin端  “右侧目录” 相关编辑 															  		  -->
<!-- ************************************************************************************************************ -->

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>admin_rightguide</title>
<script type="text/javascript" src="../../js/jquery.js"></script>
<script type="text/javascript" src="../../js/validator.js"></script>
<script type="text/javascript">
$.ajaxSetup ({
   	cache: false //关闭AJAX相应的缓存
});
</script>
<style type="text/css">
body{
background-image:url(../../image/admin_bg.png);
background-repeat:repeat-x;
margin-left: 0px;
margin-top: 0px;
margin-right: 1px;
margin-bottom: 0px;
font-family:Microsoft YaHei;
font-size:13px;
}

h2{
font-family:Microsoft YaHei;
color:#fff;
margin: 5px 5px 5px 5px;
font-size:16px;
}

</style>
</head>
<body>

<%
	//设置请求的字符编码以支持中文
	request.setCharacterEncoding ("utf-8");

	//获取请求参数

	//从web.xml获取全局参数
	String drv=config.getServletContext().getInitParameter("DBDriver");
	String url=config.getServletContext().getInitParameter("DBURL");
	String uid=config.getServletContext().getInitParameter("DBUser");
	String pwd=config.getServletContext().getInitParameter("DBPass");
	
	//构建SQL字符串和JDBC对象
	String strSQL1 = "SELECT * FROM immie0_immi.rightguide rg WHERE rg.father_id=-1";	// (id, name, content_name, content, url, father_id, date)
	Connection conn = null;
	PreparedStatement pstmt = null;	
	ResultSet rs1 = null; //父节点
	
	try {
		Class.forName(drv).newInstance();
		conn = DriverManager.getConnection(url,uid,pwd);
		pstmt = conn.prepareStatement(strSQL1);		
		
		rs1 = pstmt.executeQuery();
%>
<h2>编辑右侧目录</h2>
    
	<div id="content" style="margin:10px auto; width:400px;">
	<font>添加根目录：</font>
	<a href="AddRightguidePage.do?father_id=-1">页面</a>	
	<a href="AddRightguideLink.do?father_id=-1">链接</a>
	<br></br>	
		
<% 	while(rs1.next()) { 	%>
		<div id="rightguide1">
			<font>标题：</font><input type="text" disabled value=" <%=rs1.getString(2) %> " />
			
<% 			if(rs1.getString(5).equals("NULL")){ //content非空， url=NULL，内部页面		%>
				<a href="EditRightguidePage.do?id=<%=rs1.getString(1)%>">编辑此项</a>
<%			}
			if( rs1.getString(4).equals("NULL")){ //content=NULL， url非空，外部链接	 	%>			
				<a href="EditRightguideLink.do?id=<%=rs1.getString(1)%>">编辑此项</a>
<%			}	 		%>

			<a href="DeleteRightguide.do?id=<%=rs1.getString(1)%>" onClick="delcfm()">删除此项</a>
		</div>
				
<%	}	//第一个while 结束		%>
				 	
	</div>	
	
<%		
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (InstantiationException e) {
	    e.printStackTrace();
	} catch (IllegalAccessException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	} 
	finally {
		if (rs1 != null) {
			rs1.close();
			rs1 = null;
		}
		if (pstmt != null) {
			pstmt.close();
			pstmt = null;
		}		
		if (conn != null) {
			conn.close();
			conn = null;
		}
	}
%>

</body>
</html>